﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 促销信息管理实体类：fanli_promotion 。
	/// </summary>
	[Serializable]
	public class fanli_promotion
	{
		public fanli_promotion()
		{}

		#region Model
		private int _id; //id
		private int _shopid; //商城id
		private string _title; //标题
		private string _content; //内容
		private DateTime? _expiredDate; //过期日期
		private string _gotoUrl; //跳转链接
		private DateTime? _pubDate; //发布日期
		private int _adminID; //发布人id
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 商城id
		/// </summary>
		public int shopid
		{
			set{ _shopid=value;}
			get{return _shopid;}
		}
        /// <summary>
		/// 标题
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 内容
		/// </summary>
		public string content
		{
			set{ _content=value;}
			get{return _content;}
		}
        /// <summary>
		/// 过期日期
		/// </summary>
		public DateTime? expiredDate
		{
			set{ _expiredDate=value;}
			get{return _expiredDate;}
		}
        /// <summary>
		/// 跳转链接
		/// </summary>
		public string gotoUrl
		{
			set{ _gotoUrl=value;}
			get{return _gotoUrl;}
		}
        /// <summary>
		/// 发布日期
		/// </summary>
		public DateTime? pubDate
		{
			set{ _pubDate=value;}
			get{return _pubDate;}
		}
        /// <summary>
		/// 发布人id
		/// </summary>
		public int adminID
		{
			set{ _adminID=value;}
			get{return _adminID;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
促销信息管理,promotion
id,商城id,标题,内容,过期日期,跳转链接,发布日期,发布人id,扩展1,扩展2
id,shopid,title,content,expiredDate,gotoUrl,pubDate,adminID,ext1,ext2
i,i,c256,t,d,c256,d,i,c100,c100



--------------------------
-- 创建表[促销信息管理]开始: 
-- alter table  [fanli_promotion] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_promotion') drop table fanli_promotion
  CREATE TABLE [fanli_promotion] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [shopid] int,
	 [title] [varchar] (256),
	 [content] [text],
	 [expiredDate] [datetime],
	 [gotoUrl] [varchar] (256),
	 [pubDate] [datetime],
	 [adminID] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'促销信息管理 ',N'user',N'dbo',N'table',N'fanli_promotion', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'商城id',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'shopid'
 exec sp_addextendedproperty N'MS_Description',N'标题',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'内容',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'content'
 exec sp_addextendedproperty N'MS_Description',N'过期日期',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'expiredDate'
 exec sp_addextendedproperty N'MS_Description',N'跳转链接',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'gotoUrl'
 exec sp_addextendedproperty N'MS_Description',N'发布日期',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'pubDate'
 exec sp_addextendedproperty N'MS_Description',N'发布人id',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'adminID'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_promotion',N'column',N'ext2'

-- 创建表[促销信息管理]结束。 
--------------------------

		*/
		#endregion document
	}
}

